iLoADER

HOME

Data engineering

iLoader allows you to perform data engineering and transformation on loaded data. Data engineering can be performed when the data is loaded or at a later date.

The full range of data engineering usage is not described here, for full details see the Best Practice document 'Data Engineering in Campaign Manager and Engine' in the Campaign Manager online help.`

Create and edit your data engineering commands in the Data Transformation script files. It is recommended that you use the Data Transformation wizard to help you. For example, you can set up data engineering functions such as:

  • Decode remapping - maps abbreviated codes into real words, for example, 'HO' becomes 'Home owner'
  • Numeric remapping - groups numerical data
  • Quantile remapping - groups numeric data into sets containing equal numbers of values
  • Function remapping - applies functions to database columns
  • Parametric remapping - creates fields containing values based on queries
  • Expression field creation
  • Aggregate field creation

You can also define the relationship between tables in the database using the LINK command.

Re-engineered fields are automatically indexed. If you want to create a field that is unindexed, add a U to the beginning of the command, as shown in this Expression-based dynamic field: UEXPRESSION [test].[person] , UFullName , {[Forename] + ' ' + [Surname]}.

For full details of the available data engineering commands, see Data Transformation commands.

Any data engineering processes performed in (Undefined variable: Variables.ProductName2) can be captured and recorded as iLoader scripts using the ScriptCreator utility.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice